| HsRoomMateMatchCriteria |
| Logical Entity Name | HsRoomMateMatchCriteria |
| Default Table Name | HsRoomMateMatchCriteria |
| Physical Only | NO |
| Definition | |
| Note |
| HsRoomMateMatchCriteria Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
HsRoomMateMatchCriteriaID |
int | NO | ||
HSRoomMateMatchID |
int | NO | ||
SyGroupsID |
int | YES | ||
| AdProgramVersionID | varchar(max) | YES | ||
| ProgramStartDateFrom | datetime | YES | ||
| ProgramStartDateTo | datetime | YES | ||
| GraduationDateFrom | datetime | YES | ||
| GraduationDateTo | datetime | YES | ||
| ApplicationSubmittDateRangeFrom | datetime | YES | ||
| ApplicationSubmittDateRangeTo | datetime | YES | ||
AdTermID |
int | YES | ||
| HousingStartDate | datetime | NO | ||
| HousingEndDate | datetime | NO | ||
| PackagedOnly | bit | YES | ||
UserID |
int | NO | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
| Ts | timestamp | NO | ||
| MatchingThresholdValue | smallint | NO | ||
| AcademicYear | bit | NO | ||
| HousingDateFilled | bit | NO | ||
| LeaseStartDate | datetime | YES | ||
| LeaseEndDate | datetime | YES |
| HsRoomMateMatchCriteria Primary and Unique Keys |
| Key Name | Key Type | Keys |
| PK_HsRoomMateMatchCriteria_HsRoomMateMatchCriteriaID | PrimaryKey | HsRoomMateMatchCriteriaID |
| HsRoomMateMatchCriteria Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| AdTerm | Non-Identifying | Zero or One to Zero or More | FK_HsRoomMateMatchCriteria_AdTermID_AdTerm_AdTermID | AdTermID | NO | YES | ||
| HSRoomMateMatch | Non-Identifying | One To Zero or More | FK_HsRoomMateMatchCriteria_HSRoomMateMatchID_HSRoomMateMatch_HSRoomMateMatchID | HSRoomMateMatchID | NO | YES | ||
| SyGroups | Non-Identifying | Zero or One to Zero or More | FK_HsRoomMateMatchCriteria_SyGroupsID_Sygroups_SygroupsID | SyGroupsID | NO | YES | ||
| SyStaff | Non-Identifying | One To Zero or More | FK_HsRoomMateMatchCriteria_UserID_SyStaff_SyStaffID | UserID | NO | YES |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| HsRoomMateMatchStudent | Non-Identifying | One To Zero or More | FK_HsRoomMateMatchStudent_HsRoomMateMatchCriteriaID_HsRoomMateMatchCriteria_HsRoomMateMatchCriteriaID | NO | YES |
| HsRoomMateMatchCriteria Check Constraints |
| Check Constraint Name | CheckConstraint |